RCG Salesforce Marketing System API - Implementation Template
Data mappings
This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.
Module | Description |
---|---|
retrieve-individul-dataextension | Salesforce Data Extension to CIM format mapping |
subscribers-create-individual | CIM format to Salesforce create Individual request mapping |
subscribers-create-subscriber | CIM format to Salesforce create subscriber request mapping |
subscribers-update-subscriber | CIM format to Salesforce update data extension request mapping |
retrieve-individul-dataextension
Salesforce Data Extension to CIM format mapping
Source:
./src/main/resources/dwl/retrieve-individul-dataextension.dwl
Mapping Tables
Maps Salesforce Data Extension to CIM format
CIM | Salesforce Data Extension | Description |
---|---|---|
partyType | Individual | Hardcoded party type to Individual |
PersonName | personName | The full name of the Individual |
id | SubscriberId | The subscriber Id |
firstName | FirstName | The Individual first name |
lastName | LastName | The Individual Last name |
contactPointType | ContactPointEmail | Hardcoded contact type to ContactPointEmail |
id | SubscriberId | The subscriber Id |
activeFromDate | todays date | The Individual Active from date is hardcoded to todays date |
emailAddress | EmailAddress | The Individual contact email address |
externalIds.id | GlobalPartyId | Id field is hardcoded as empty string |
externalIds.externalId | GlobalPartyId | The Individual Global Id |
externalIds.externalIdType | MDM | The Global Id of Individual as in MDM that is being stored in Salesforce |
externalIds.statusLastChangedDate | CreatedDate | created date to "yyyy-MM-dd'T'HH:mm:ssz" |
externalIds.status | VALID | The Individual status is hardcoded as VALID |
auditInfo.createdDate | CreatedDate | The Individual created date to "yyyy-MM-dd'T'HH:mm:ssz" |
auditInfo.createdBy | createdBy | The last Individual created by user name |
auditInfo.updatedDate | updatedDate | The last updated date to "yyyy-MM-dd'T'HH:mm:ssz" |
auditInfo.updatedBy | UpdatedBy | The last modified user name |
auditInfo.isDeleted | false | returns true if user deleted else false |
subscribers-create-individual
CIM format to Salesforce create Individual request mapping
Source:
./src/main/resources/dwl/subscribers-create-individual.dwl
Mapping Tables
Maps CIM format to Salesforce data extension Object
Salesforce data extension Object | CIM | Description |
---|---|---|
concreteClassType | DataExtensionObject | Hardcoded as DataExtensionObject |
name | Individual | Hardcoded as Individual |
properties.property.name | EmailAddress | Hardcoded as email address |
properties.property.value | emailAddress | The subscriber email |
properties.property.name | GlobalPartyId | Hardcoded as global party Id |
properties.property.value | externalId | The external Id matches MDM |
properties.property.name | SubscriberId | Hardcoded as SubscriberId |
properties.property.value | Id | The subscriber Id |
properties.property.name | FirstName | Hardcoded as FirstName |
properties.property.value | firstName | The FirstName of the Individual |
properties.property.name | LastName | Hardcoded as LastName |
properties.property.value | lastName | The LastName of the Individual |
properties.property.name | PersonName | Hardcoded as PersonName |
properties.property.value | personName | The Full name of the Individual |
properties.property.name | CreatedDate | Hardcoded as CreatedDate |
properties.property.value | todays date | Hardcoded today datetime to "yyyy-MM-dd HH:mm:dd" |
properties.property.name | CreatedBy | Hardcoded as CreatedBy |
properties.property.value | app.name | The application name |
properties.property.name | UpdatedDate | Hardcoded as UpdatedDate |
properties.property.value | todays date | Hardcoded today datetime to "yyyy-MM-dd HH:mm:dd" |
properties.property.name | UpdatedBy | Hardcoded as UpdatedBy |
properties.property.value | app.name | The application name |
subscribers-create-subscriber
CIM format to Salesforce create subscriber request mapping
Source:
./src/main/resources/dwl/subscribers-create-subscriber.dwl
Mapping Tables
Maps CIM format to Salesforce Marketing Individual subscriber mapping
Salesforce subscriber | CIM | Description |
---|---|---|
CreatedDate | todays date time | The created date to now |
EmailAddress | emailAddress | The email address of the subscriber |
ModifiedDate | todays date time | The modified date to "yyyy-MM-dd'T'HH:mm:ssz" |
SubscriberKey | emailAddress | The email address of the subscriber |
subscribers-update-subscriber
CIM format to Salesforce update data extension request mapping
Source:
./src/main/resources/dwl/subscribers-update-subscriber.dwl
Mapping Tables
Maps CIM format to Salesforce data extension Object
Salesforce data extension Object | CIM | Description |
---|---|---|
concreteClassType | DataExtensionObject | Hardcoded as DataExtensionObject |
name | Individual | Hardcoded as Individual |
properties.property.name | EmailAddress | Hardcoded as email address |
properties.property.value | emailAddress | The Individual subscriber email |
properties.property.name | GlobalPartyId | Hardcoded as global party Id |
properties.property.value | externalId | The external Id matches MDM |
properties.property.name | SubscriberId | Hardcoded as SubscriberId |
properties.property.value | Id | The subscriber id |
properties.property.name | FirstName | Hardcoded as FirstName |
properties.property.value | firstName | The FirstName of the Individual |
properties.property.name | LastName | Hardcoded as LastName |
properties.property.value | lastName | The LastName of the Individual |
properties.property.name | PersonName | Hardcoded as PersonName |
properties.property.value | personName | The Full name of the Individual |
properties.property.name | CreatedDate | Hardcoded as CreatedDate |
properties.property.value | todays date | Hardcoded today datetime to "yyyy-MM-dd HH:mm:dd" |
properties.property.name | CreatedBy | Hardcoded as CreatedBy |
properties.property.value | app.name | The application name |
properties.property.name | UpdatedDate | Hardcoded as UpdatedDate |
properties.property.value | todays date | Hardcoded today datetime to "yyyy-MM-dd HH:mm:dd" |
properties.property.name | UpdatedBy | Hardcoded as UpdatedBy |
properties.property.value | app.name | The application name |